And operator

Basic and Crystal syntax.

Usage

x And y

Value of x Value of y x And y

True

True

True

True

False

False

False

True

False

False

False

False

Examples

The following example is applicable to Crystal syntax:

If {file.CREDIT LIMIT} = 5000 and {file.SALESMAN} = "SP" Then

    {file.AMOUNT}

Else

    0

If the credit limit is 5000 and the salesman is SP (both conditions true), then returns the value in the {file.AMOUNT} field, otherwise return zero.

A > B and B > C

Returns TRUE, where A = 10, B = 6, and C = 3 (both conditions are true).

Returns FALSE, where A=10, B=6, and C=7 (only one of the two conditions are true).

(A>B) and (A * C - D > E) and (E / D <= B)

Returns TRUE, where A = 7, B = 5, C = 3, D = 2, E = 10 (all three of the conditions are true).

Related topics

Order of precedence (Basic syntax)

Order of precedence (Crystal syntax)

Formula 6

Formula 15



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com